package com.seecen.letao.mapper.forumMapper;

import com.seecen.letao.pojo.forumPojo.Article;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

import java.util.List;

@Mapper //mybatis  mapper注解
@Repository //持久层注解
public interface ArticleMapper {

//    @Select("select * from t_article,")
    @Select("select t1.*,t2.USERNAME from  T_ARTICLE t1 left join T_USER t2 on t1.CID=t2.ID")
    List<Article> selectAll();

}
